coldfusion string functions

[Pick] String manipulation functions are available in the following ways:find,findnocase,findoneof,replace,compareFind: Find (substring, string [, start]), finds the starting position of substring in string, returns a number, and returns 0 if it is not found. This function is case-sensitive, that is, it is a casing-sen

()-- Dateadd (date part, value to be added, date): add the corresponding value according to the specified date part.Select dateadd (mm, 2, '2014/1/1') -- display 2013/2Select dateadd (YY,-2, '2014/1 ') -- display 2013/2-- Datediff (date part, date 1, date 2): Calculate the gap between two dates based on the date part (I .e., date 2-date 1)Select datediff (mm, '2014/1/1', '2014/3/5') -- display 5Select datediff (mm, '2014/1/5', '2014/3/1') -- show-5-- Datename (date part, date): obtains the

Single-record functions in SQL1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ascii ('A') A, ascii ('A') A, ascii ('0') zero, ascii ('') space from dual;A ZERO SPACE------------------------------------65 97 48 322. CHRReturns the corresponding characters;SQL> select chr (54740) zhao, chr (65) chr65 from dual;ZH C---Zhao3. CONCATConnect two strings;SQL> select concat ('010-', '000000') |' to 23' Gao Qian competin

Single record function in SQL 1. ASCII returns the decimal number corresponding to the specified character; SQLselectascii (A) A, ascii (a) a, ascii (0) zero, ascii () spacefromdual; The AAZEROSPACE------------------------------------659748322.CHR gives the integer, returns the corresponding character; SQLselect Single record function in SQL 1. ASCII returns the decimal number corresponding to the specified character. SQL select ascii (A) A, ascii (a) a, ascii (0) zero, ascii () space from dual;

ProductName OrderDate 1 Computer 2008-12-26 2 Printer 2008-12-26 3 Electrograph 2008-11-12 4 Telephone 2008-10-19 Now, we want to select a record from the table above that OrderDate is "2008-12-26".We use the following SELECT statement:SELECT * from Orders WHERE orderdate= ' 2008-12-26 'Result set: OrderId ProductName OrderDate 1

C string and string functions (1), c string functions String is a very common data type in C language. Learning to master the string has a certain effect on understanding the pointer o

Oracle function Daquan (string function, mathematical function, date function,: 25sql single record function 1. ASCII returns the decimal number corresponding to the specified character. SQL> select ASCII ('A') A, ASCII ('A') A, ASCII ('0') zero, ASCII ('') space from dual; A a zero space --------- 65 97 48 32 2. CHRReturns the corresponding characters;SQL> select CHR (54740) Zhao, CHR (65) chr65 from dual;Zh C---Zhao3. ConcatConnect two strings;SQL>

Functions in a database are similar to functions in C #sequentially,The price is special here.Print can be printed in the Message bar.Mathematical functionsCeiling () The upper limit does not care how big the decimal point is, directly ignoreFloor () lower limit ibid.Round (column name, number of reserved digits) rounding reserved decimals the last digit in the number of reserved digits is not enough for th

Label: 2 --Mathematical Functions 3 Select CEILING(COUNT(*)/5.0) fromNews--take the smallest integer greater than the result 4 Select Floor(COUNT(*)/5.0) fromNews--take the largest integer less than the result 5 Select SQRT(2)--Value Open Square 6 Select ROUND(3.45645,2) 7 Select ABS(-5): The absolute value function, which takes the absolute value of this number, can be applied to the addition and subtraction of some of the more chaotic values in the

', title) from News--the query target content does not appear in the specified area and appears in the location of the Select REPLACE (Title, ' China ', ' us ') from news--the replacement string. Example searches for keywords and significantly selects STUFF (title,3,4, ' Chine ') from News 22 other functions of the 1 Select CEILING (RAND () *10)--randomly generated numbers between The range of random numbe

Common string operation functions in PHP development, and string functions in php Development 1. concatenate stringsConcatenating strings is one of the most common string operations. In PHP, You Can concatenate strings in three ways: Dots. separator {} operation, and dot equ

Single-record functions in SQL 1. ASCIIReturns the decimal number corresponding to the specified character;SQL> select ascii ('A') A, ascii ('A') A, ascii ('0') zero, ascii ('') space from dual;A ZERO SPACE------------------------------------65 97 48 322. CHRReturns the corresponding characters;SQL> select chr (54740) zhao, chr (65) chr65 from dual;ZH C---Zhao3. CONCATConnect two strings;SQL> select concat ('010-', '000000') |' to 23' Gao Qian competi

decimal value of the N1, N2 the default is set to 0, when N2 is the default setting N1 truncated to an integer, if the N2 is negative, it is truncated in the corresponding bit to the left of the decimal point.For example: SELECT TRUNC (23.56), TRUNC (23.56,1), TRUNC (23.56,-1) from DUAL;(ii). Character functions return character values (Character Functions returning Character values)The class function retu

PHP-Based String operation functions and php string functions 1. Search for the character location function: Strpos ($ str, search, [int]): // search for the first position of search in $ str starting from int; strrpos ($ str, search, [int]): // search for the last occurrence position of search in $ str starting from i

String library functions ----------- summarize some common string processing functions. Header file: # include First place Char * strstr (char * dest, char * need ); Locate the position where the need string appears from the dest stri